package LawsonTransformJava.data;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;


public class TblTAEmpServ {
	public int		company		=0; 
	public int		employee	=0; 
	public int		tes_obj_id	=0; 
	public String 	service_code	=null; 
	public int		event_flag	=0; 
	public String 	reason_code	=null; 
	public int		event_type	=0; 
	public int		plan_balance	=0; 
	public int		service_status	=0; 
	public int		event_status	=0; 
	public int		r_status	=0; 
	public int		time_seq	=0; 
	public int		ext_time_seq	=0; 
	public Date		tr_date		=null;
	public Date		per_end_date	=null; 
	public String 	process_level	=null; 
	public String 	hm_proc_level	=null; 
	public String 	department	=null; 
	public String 	position	=null; 
	public String 	job_code	=null; 
	public float	hours		=0; 
	public float	wage_amount	=0; 
	public String 	currency_code	=null; 
	public int		curr_nd		=0; 
	public int		pcd_seq_nbr	=0; 
	public float	points		=0; 
	public String 	occurrence	=null; 
	public int		days_ind	=0; 
	public Date		create_date	=null; 
	public int		create_time	=0; 
	public String 	create_user_id	=null; 
	public Date		date_stamp	=null;
	public int		time_stamp	=0; 
	public String 	user_id		=null; 
	public String 	l_index		=null; 
	public String 	tesset2_ss_sw	=null; 
	public String 	tesset3_ss_sw	=null; 
	public String 	tesset4_ss_sw	=null; 
	public String 	tesset5_ss_sw	=null; 
	public String 	tesset6_ss_sw	=null; 
	public String 	tesset8_ss_sw	=null; 
	public String 	l_attes_ss_sw	=null; 
	public String 	created_ng_bal	=null;
	
	private DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
	private DateFormat df2 = new SimpleDateFormat("yyyyMMdd");
	private String text; 
	 
	public void setCompany(int company) {
		this.company = company;
	}
	public void setEmployee(int employee) {
		this.employee = employee;
	}
	public void setTes_obj_id(int tes_obj_id) {
		this.tes_obj_id = tes_obj_id;
	}
	public void setService_code(String service_code) {
		this.service_code = service_code;
	}
	public void setEvent_flag(int event_flag) {
		this.event_flag = event_flag;
	}
	public void setReason_code(String reason_code) {
		this.reason_code = reason_code;
	}
	public void setEvent_type(int event_type) {
		this.event_type = event_type;
	}
	public void setPlan_balance(int plan_balance) {
		this.plan_balance = plan_balance;
	}
	public void setService_status(int service_status) {
		this.service_status = service_status;
	}
	public void setEvent_status(int event_status) {
		this.event_status = event_status;
	}
	public void setR_status(int r_status) {
		this.r_status = r_status;
	}
	public void setTime_seq(int time_seq) {
		this.time_seq = time_seq;
	}
	public void setExt_time_seq(int ext_time_seq) {
		this.ext_time_seq = ext_time_seq;
	}
	public void setTr_date(Date tr_date) {
		this.tr_date = tr_date;
	}
	public void setPer_end_date(Date per_end_date) {
		this.per_end_date = per_end_date;
	}
	public void setProcess_level(String process_level) {
		this.process_level = process_level;
	}
	public void setHm_proc_level(String hm_proc_level) {
		this.hm_proc_level = hm_proc_level;
	}
	public void setDepartment(String department) {
		this.department = department;
	}
	public void setPosition(String position) {
		this.position = position;
	}
	public void setJob_code(String job_code) {
		this.job_code = job_code;
	}
	public void setHours(float hours) {
		this.hours = hours;
	}
	public void setWage_amount(float wage_amount) {
		this.wage_amount = wage_amount;
	}
	public void setCurrency_code(String currency_code) {
		this.currency_code = currency_code;
	}
	public void setCurr_nd(int curr_nd) {
		this.curr_nd = curr_nd;
	}
	public void setPcd_seq_nbr(int pcd_seq_nbr) {
		this.pcd_seq_nbr = pcd_seq_nbr;
	}
	public void setPoints(float points) {
		this.points = points;
	}
	public void setOccurrence(String occurrence) {
		this.occurrence = occurrence;
	}
	public void setDays_ind(int days_ind) {
		this.days_ind = days_ind;
	}
	public void setCreate_date(Date create_date) {
		this.create_date = create_date;
	}
	public void setCreate_time(int create_time) {
		this.create_time = create_time;
	}
	public void setCreate_user_id(String create_user_id) {
		this.create_user_id = create_user_id;
	}
	public void setDate_stamp(Date date_stamp) {
		this.date_stamp = date_stamp;
	}
	public void setTime_stamp(int time_stamp) {
		this.time_stamp = time_stamp;
	}
	public void setUser_id(String user_id) {
		this.user_id = user_id;
	}
	public void setL_index(String l_index) {
		this.l_index = l_index;
	}
	public void setTesset2_ss_sw(String tesset2_ss_sw) {
		this.tesset2_ss_sw = tesset2_ss_sw;
	}
	public void setTesset3_ss_sw(String tesset3_ss_sw) {
		this.tesset3_ss_sw = tesset3_ss_sw;
	}
	public void setTesset4_ss_sw(String tesset4_ss_sw) {
		this.tesset4_ss_sw = tesset4_ss_sw;
	}
	public void setTesset5_ss_sw(String tesset5_ss_sw) {
		this.tesset5_ss_sw = tesset5_ss_sw;
	}
	public void setTesset6_ss_sw(String tesset6_ss_sw) {
		this.tesset6_ss_sw = tesset6_ss_sw;
	}
	public void setTesset8_ss_sw(String tesset8_ss_sw) {
		this.tesset8_ss_sw = tesset8_ss_sw;
	}
	public void setL_attes_ss_sw(String l_attes_ss_sw) {
		this.l_attes_ss_sw = l_attes_ss_sw;
	}
	public void setCreated_ng_bal(String created_ng_bal) {
		this.created_ng_bal = created_ng_bal;
	}
	
// Getters
	
	public int getCompany() {
		return company;
	}
	public int getEmployee() {
		return employee;
	}
	public int getTes_obj_id() {
		return tes_obj_id;
	}
	public String getService_code() {
		if (service_code==null||service_code.equals(""))
		{text = "";}
	else
		{text = "\""+service_code+"\"";}
	return text;				
	}
	public int getEvent_flag() {
		return event_flag;
	}
	public String getReason_code() {
		if (reason_code==null||reason_code.equals(""))
		{text = "";}
	else
		{text = "\""+reason_code+"\"";}
	return text;			
	}
	public int getEvent_type() {
		return event_type;
	}
	public int getPlan_balance() {
		return plan_balance;
	}
	public int getService_status() {
		return service_status;
	}
	public int getEvent_status() {
		return event_status;
	}
	public int getR_status() {
		return r_status;
	}
	public int getTime_seq() {
		return time_seq;
	}
	public int getExt_time_seq() {
		return ext_time_seq;
	}
	public String getTr_date() {
		if (tr_date==null)
		{text = "";}
		else
		{String date =(tr_date!=null?df2.format(tr_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(tr_date).toString() + "\"";;}}
		return text;	
	}
	public String getPer_end_date() {
		if (per_end_date==null)
		{text = "";}
		else
		{String date =(per_end_date!=null?df2.format(per_end_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(per_end_date).toString() + "\"";;}}
		return text;	
	}
	public String getProcess_level() {
		if (process_level==null||process_level.equals(""))
		{text = "";}
	else
		{text = "\""+process_level+"\"";}
	return text;			
	}
	public String getHm_proc_level() {
		if (hm_proc_level==null||hm_proc_level.equals(""))
		{text = "";}
	else
		{text = "\""+hm_proc_level+"\"";}
	return text;			
	}
	public String getDepartment() {
		if (department==null||department.equals(""))
		{text = "";}
	else
		{text = "\""+department+"\"";}
	return text;				
	}
	public String getPosition() {
		if (position==null||position.equals(""))
		{text = "";}
	else
		{text = "\""+position+"\"";}
	return text;			
	}
	public String getJob_code() {
		if (job_code==null||job_code.equals(""))
		{text = "";}
	else
		{text = "\""+job_code+"\"";}
	return text;				
	}
	public float getHours() {
		return hours;
	}
	public float getWage_amount() {
		return wage_amount;
	}
	public String getCurrency_code() {
		if (currency_code==null||currency_code.equals(""))
		{text = "";}
	else
		{text = "\""+currency_code+"\"";}
	return text;		
	}
	public int getCurr_nd() {
		return curr_nd;
	}
	public int getPcd_seq_nbr() {
		return pcd_seq_nbr;
	}
	public float getPoints() {
		return points;
	}
	public String getOccurrence() {
		if (occurrence==null||occurrence.equals(""))
		{text = "";}
	else
		{text = "\""+occurrence+"\"";}
	return text;		
	}
	public int getDays_ind() {
		return days_ind;
	}
	public String getCreate_date() {
		if (create_date==null)
		{text = "";}
		else
		{String date =(create_date!=null?df2.format(create_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(create_date).toString() + "\"";;}}
		return text;	
	}
	public int getCreate_time() {
		return create_time;
	}
	public String getCreate_user_id() {
		if (create_user_id==null||create_user_id.equals(""))
		{text = "";}
	else
		{text = "\""+create_user_id+"\"";}
	return text;			
	}
	public String getDate_stamp() {
		if (date_stamp==null)
		{text = "";}
		else
		{String date =(date_stamp!=null?df2.format(date_stamp).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(date_stamp).toString() + "\"";;}}
		return text;	
	}
	public int getTime_stamp() {
		return time_stamp;
	}
	public String getUser_id() {
		return user_id;
	}
	public String getL_index() {
		if (l_index==null||l_index.equals(""))
		{text = "";}
	else
		{text = "\""+l_index+"\"";}
	return text;			
	}
	public String getTesset2_ss_sw() {
		if (tesset2_ss_sw==null||tesset2_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+tesset2_ss_sw+"\"";}
	return text;			
	}
	public String getTesset3_ss_sw() {
		if (tesset3_ss_sw==null||tesset3_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+tesset3_ss_sw+"\"";}
	return text;	
	}
	public String getTesset4_ss_sw() {
		if (tesset4_ss_sw==null||tesset4_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+tesset4_ss_sw+"\"";}
	return text;	
	}
	public String getTesset5_ss_sw() {
		if (tesset5_ss_sw==null||tesset5_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+tesset5_ss_sw+"\"";}
	return text;	
	}
	public String getTesset6_ss_sw() {
		if (tesset6_ss_sw==null||tesset6_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+tesset6_ss_sw+"\"";}
	return text;	
	}
	public String getTesset8_ss_sw() {
		if (tesset8_ss_sw==null||tesset8_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+tesset8_ss_sw+"\"";}
	return text;	
	}
	public String getL_attes_ss_sw() {
		if (l_attes_ss_sw==null||l_attes_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+l_attes_ss_sw+"\"";}
	return text;		
	}
	public String getCreated_ng_bal() {
		if (created_ng_bal==null||created_ng_bal.equals(""))
		{text = "";}
	else
		{text = "\""+created_ng_bal+"\"";}
	return text;				
	} 

	
	
}
